package org.dey.mapper;

import org.apache.ibatis.annotations.Select;

public interface NumbersMapper {

    @Select("SELECT file_number FROM t_member ORDER BY id DESC LIMIT 0,1")
    public String memberid();

    @Select(" SELECT DESIGN_ID FROM D_MODULE ORDER BY id DESC LIMIT 0,1")
    public String dM0duleid();

    @Select(" SELECT  DESIGN_ID FROM M_DESIGN_PROCEDURE ORDER BY id DESC LIMIT 0,1")
    public String mDesignProcedureid();

    @Select(" SELECT APPLY_ID FROM M_APPLY ORDER BY id DESC LIMIT 0,1")
    public String mApplyid();

    @Select(" SELECT MANUFACTURE_ID FROM  M_MANUFACTURE ORDER BY id DESC LIMIT 0,1")
    public String mManufactureid();

    @Select("SELECT STORE_ID FROM S_CELL ORDER BY id DESC LIMIT 0,1")
    public String sCellid();

    @Select("SELECT GATHER_ID FROM S_GATHER ORDER BY id DESC LIMIT 0,1")
    public String sGatherid();

    @Select("SELECT PAY_ID FROM S_PAY ORDER BY id DESC LIMIT 0,1")
    public String sPayid();

}
